The following tables describe how the UCAS column details are mapped onto EBS tables and columns:
UCAS applicant details
Note that the UCAS HE Incoming data overwrites EBS data institution setting determines which value EBS uses when both UCAS and EBS contain data for the same field.
-
If the setting is enabled, EBS uses the UCAS value.
-
If the setting is disabled, EBS keeps the existing EBS value.
-
A blank value never clears existing data. If the preferred source is blank for a field, EBS uses the value from the other source.
-
When the UCAS import finds an applicant who does not already exist in EBS, it creates a person record using the UCAS data.
UCAS fields that are not listed here remain in the UCAS staging tables and are not copied to EBS.
The table UCAS applicant details (UCAS_APPLICANT_DETAILS) describes the mappings between UCAS and EBS.
| UCAS column | EBS table/column | Notes |
|---|---|---|
|
Surname |
People.surname |
None |
|
DateofBirth |
People.date_of_birth |
Blank if outside institution settings for minimum and maximum age. |
|
Firstname |
People.forename People.middle_names |
Updated in 4.44 to split into forename and middle names. |
|
Title |
People.title |
Matched to a Title reference data value, unmatched titles are left blank. |
|
Gender |
People.sex |
|
|
NationalInsuranceNumber |
People.ni_number |
None |
|
MobilePhoneNo |
People.mobile_phone_number |
None |
|
NominatedName |
People.fes_next_of_kin |
None |
|
NominatedRelationship |
People.fes_nok_cont_rel |
None |
|
DateEnteredUk |
People.date_uk_entry |
Added in 4.45. |
|
EmailAddress |
People.personal_email |
None |
|
countryOfBirthCode |
People.place_of_birth |
|
|
preferredFirstname |
People.known_as People.preferred_first_name |
Added in 4.45. |
|
uniqueLearnerNumber |
People.unique_learn_no |
None |
|
personalID |
People_ilr.ucasperid |
None |
|
nationalityCode |
People.Nationality |
UCAS nationality reference data code lookup, added in 4.44. |
|
None |
Addresses.address_type |
UCAS HE institution setting > UCAS HE EBS Address Type. |
|
None |
Addresses.start_date |
Import date. |
|
None |
Addresses.owner_type |
Hard-coded to P. |
|
Address1 |
Addresses.address_line_1 |
None |
|
Address2 |
Addresses.address_line_2 |
None |
|
Address3 |
Addresses.address_line_3 |
None |
|
Address4 |
Addresses.address_line_4 |
None |
|
Postcode |
Addresses.uk_post_code_pt1 Addresses.uk_post_code_pt2 |
Postcode is standardised before it is stored, and blanked if in an invalid format. |
UCAS applicant qualifications
The table UCAS applicant qualifications (UCAS_APPLICANT_QUALIFICATIONS) describes the mappings between UCAS and EBS.
| UCAS column | EBS table/column | Notes |
|---|---|---|
|
None |
Attainments.atype_attainment_type_code |
UCAS HE institution setting > UCAS HE Qualification on Entry code. |
|
subjectOrCourse |
Attainments.description |
Attainment description is levelcode – subjectOrCourse. |
|
levelCode |
Attainments.description |
Attainment description is levelcode – subjectOrCourse. |
|
entrydateyear |
Attainments.fes_year_achieved |
If |
|
resultOrClass |
Attainments.grade |
None |
|
predictedGrades |
Attainments.fes_predicted_grade |
None |
UCAS applicant choices
The table UCAS applicant choices (UCAS_APPLICANT_CHOICES) describes the mappings between UCAS and EBS.
| UCAS column | EBS table/column | Notes |
|---|---|---|
|
None |
People_units.unit_type |
Hard-coded to A. |
|
None |
Existing applications are only updated if the UCAS HE institution setting, UCAS HE Allow UCAS to update existing applications, is set to Yes. The progress code is not changed if the existing progress code is included in the UCAS progress code exclusions reference data.
|
|
|
None |
People_units.progress_date |
Import date. |
|
None |
People_units.who_to_pay |
Applications institution setting > Who to pay. |
|
None |
People_units.record_date |
Import date. |
|
courseCode |
None |
Used to find matching EBS UIO, |
|
yearOfEntry |
None |
Used to find matching EBS UIO, |
|
pointOfEntry |
None |
Used to find matching EBS UIO, |
|
MonthEntry |
None |
Optionally used in course matching from 4.47 based on the UCAS HE institution setting, UCAS HE Course matching uses Month of Entry. |
|
campus |
None |
UCAS HE institution setting, UCAS HE Campus mapping preference. If blank, not used. Also, UCAS campus reference data. |
|
criminalRecordDeclaration |
None |
Used to indicate whether an applicant has declared a criminal record, added in 4.48. |
UCAS applicant background
The table UCAS applicant background (UCAS_APPLICANT_BACKGROUND) describes the mappings between UCAS and EBS.
| UCAS column | EBS table/column | Notes |
|---|---|---|
|
ethnicCode |
People.Ethnicity |
Reference data lookup on Ethnicity, added in 4.44. |
UCAS applicant living with conditions
The table UCAS applicant living with conditions (UCAS_APP_LIVING_WITH CONDITION) describes the mappings between UCAS and EBS.
| UCAS column | EBS table/column | Notes |
|---|---|---|
|
Code |
Disabilities.Disability_type |
Reference data lookup onUCAS disability, added in 4.48. |
|
Codes |
Disabilities.Disability_type |
Comma separated list and will be used from 2027 application cycle, added in 4.51. |
|
AdditionalNeeds |
Notes.Notes |
Note linked to the disability record. |
|
None |
Disabilities.Long_Description |
Set as See notes for further information, if |
|
LastUpdated |
Disabilities.Start_date |
None |